package com.example.mapper.configuration;

import com.example.bean.configuration.JiGou;
import com.example.bean.configuration.ShouFeiBiaoZhun;
import com.example.bean.configuration.vo.ShouFeiBiaoZhunVo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ShouFeiBiaoZhunMapper {
    @Select("select noid, jigou_name, establishment_ofTheSubject from t_basicinformation ")
    List<JiGou> xiala();

    List<ShouFeiBiaoZhun> getpage(ShouFeiBiaoZhunVo vo);

    Integer addsfbz(ShouFeiBiaoZhun shouFeiBiaoZhun);
    @Select("select * from shoufei where noid = #{aid}")
    ShouFeiBiaoZhun getId(String aid);
    @Update("UPDATE shoufei SET jigou_id = #{jigouid}, sx_year = #{sxyear}, bz_money = #{bzmoney}, fangshi = #{fangshi}, " +
            "zhouqi = #{zhouqi}, zl_a = #{zla}, zl_b = #{zlb}, zl_c = #{zlc}, fx_a = #{fxa}, fx_b = #{fxb}, fx_c = #{fxc}, " +
            "fx_d = #{fxd}, pd_hy = #{pdhy}, qb_g = #{qbg}, qb_d = #{qbd}, fx_hl_g = #{fxhlg}, fx_hl_d = #{fxhld}, " +
            "fx_ss_g = #{fxssg}, fx_ss_d = #{fxssd}, fx_cw_g = #{fxcwg}, fx_cw_d = #{fxcwd}, yj_g = #{yjg}, yj_d = #{yjd}, " +
            "qt_sdf = #{qtsdf}, qt_qnf = #{qtqnf}, qt_qt = #{qtqt} where noid = #{noid}")
    Integer xiugai(ShouFeiBiaoZhun shouFeiBiaoZhun);

    Integer dels(List<String> ids);
}
